USE [Training]
GO

IF NOT EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.training_api_SkillUpdate'))
	EXEC('CREATE PROC dbo.training_api_SkillUpdate AS')
GO

ALTER PROC dbo.training_api_SkillUpdate
	@Title		nvarchar(200),
	@DocID		int = null,
	@SkillID	int 
AS
	UPDATE Skill
	SET
		Title = @Title,
		DocID = @DocID
	WHERE
		SkillID = @SkillID
